#!/bin/ksh
LOGIN=csmsp/csmsp@dev 

echo $LOGIN LOGIN 
sqlplus -s $LOGIN<<!
delete from ccs.ccs_ams_h_abnormal_usage 
where report_date < sysdate - 365 ;

delete from ccs.ccs_ams_h_action_log 
where upd_date < sysdate - 365 ; 

delete from ccs.ccs_ams_h_call_log 
where upd_date < sysdate - 365 ;

delete from ccs.ccs_ams_h_case_record
where upd_date < sysdate - 365  ;
commit ;
!
